use online_news_editorial;
go

--insert into table_name(column1, column2) values('', '');

insert into Divisions values('div001', 'Editorial', 'ban bien tap');
insert into Divisions values('div002', 'News', 'ban thoi su');
insert into Divisions values('div003', 'Entertainment', 'ban giai tri');
insert into Divisions values('div004', 'Sport', 'ban the thao');
insert into Divisions values('div005', 'Digital', 'ban so hoa');
go


insert into Jobs values('job0001', 'Editor in Chief', 'tong bien tap', null, null);
insert into Jobs values('job0002', 'Subeditor', 'thu ky toa soan', null, null);
insert into Jobs values('job0003', 'Chief of News Division', 'truong ban thoi su', null, null);
insert into Jobs values('job0004', 'Chief of Enterainment Division', 'truong ban giai tri', null, null);
insert into Jobs values('job0005', 'Chief of Sport Division', 'truong ban the thao', null, null);
insert into Jobs values('job0006', 'Chief of Digital Division', 'truong ban so hoa', null, null);
insert into Jobs values('job0007', 'News Editor', 'bien tap vien (ban thoi su)', null, null);
insert into Jobs values('job0008', 'Entertainment Editor', 'bien tap vien (ban giai tri)', null, null);
insert into Jobs values('job0009', 'Sport Editor', 'bien tap vien (ban the thao)', null, null);
insert into Jobs values('job0010', 'Digital Editor', 'bien tap vien (ban so hoa)', null, null);
insert into Jobs values('job0011', 'Correspondent', 'phong vien', null, null);
go

insert into Categories values('cat0001', null, 'News', 'chuyen muc thoi su', 'div002');
insert into Categories values('cat0002', null, 'Entertainment', 'chuyen muc giai tri', 'div003');
insert into Categories values('cat0003', null, 'Sport', 'chuyen muc the thao', 'div004');
insert into Categories values('cat0004', null, 'Digital', 'chuyen muc so hoa', 'div005');
insert into Categories values('cat0005', 'cat0001', 'World News', 'thoi su quoc te', 'div002');
insert into Categories values('cat0006', 'cat0001', 'Viet Nam News', 'thoi su trong nuoc', 'div002');
insert into Categories values('cat0007', 'cat0002', 'Movie', 'dien anh', 'div003');
insert into Categories values('cat0008', 'cat0002', 'Music', 'am nhac', 'div003');
go

--insert into aspnet_Roles values('', 'A5ABBE5A-A7B8-44FD-8872-F7F724A0DB85', 'Approver', 'Publisher');
--insert into aspnet_Roles values('', 'B3DE010E-9EBD-42E7-9DC9-10DD676DFCE9', 'Editor', 'Editor');
--insert into aspnet_Roles values('', 'C129DCAF-58EA-4348-8A5C-0ABEB512D70B', 'Writer', 'Correspondent');
--insert into aspnet_Roles values('', '6C4E07FD-D1C4-4255-A017-2C65FF2EDDA5', 'WebAdmin', 'WebAdmin');
--insert into aspnet_Roles values('', '804C0BA7-B330-4724-A024-75A4EA04F6F5', 'SysAdmin', 'SysAdmin');
--go

